![]()
Home page
![]()
Release Information
![]()
Reality on the Web
![]()
MultiValue Compatibility
![]()
Documentation Overview
![]()
Installation Guides
![]()
User's Reference
![]()
English Reference
![]()
Proc Reference
![]()
DataBasic Reference
![]()
Editor Reference
![]()
Screen Editor Reference
![]()
Resilience
![]()
SQL for Reality
![]()
![]()
About this Section
![]()
![]()
![]()
Introduction
![]()
![]()
![]()
![]()
Software Compliance
![]()
![]()
![]()
![]()
Assumed Knowledge
![]()
![]()
![]()
![]()
Contents
![]()
![]()
![]()
Related Documents
![]()
![]()
![]()
Conventions
![]()
![]()
Introduction to SQL for Reality
![]()
![]()
![]()
Introduction
![]()
![]()
![]()
![]()
What are ODBC and JDBC?
![]()
![]()
![]()
![]()
SQL for Reality
![]()
![]()
![]()
![]()
SQL/JDBC
![]()
![]()
![]()
![]()
Standards
![]()
![]()
![]()
SQL/ODBC for Reality
![]()
![]()
![]()
![]()
RealSQL Driver
![]()
![]()
![]()
![]()
Distributed Transactions
![]()
![]()
![]()
SQL/JDBC for Reality
![]()
![]()
![]()
Reality Database as an SQL Data Source
![]()
![]()
![]()
Accessing Reality Files using SQL
![]()
![]()
![]()
![]()
What is a Reality SQL Catalog?
![]()
![]()
![]()
![]()
Client/Server Interface
![]()
![]()
![]()
![]()
Definition of the SQL Environment in Reality
![]()
![]()
![]()
![]()
Administration Using SQLM
![]()
![]()
![]()
![]()
Setting up an SQL Catalog
![]()
![]()
![]()
![]()
Multiple Account Catalogs
![]()
![]()
![]()
![]()
SQL-Reality Relationships
![]()
![]()
![]()
SQL Catalog Files
![]()
![]()
![]()
![]()
SQLTABLES File
![]()
![]()
![]()
![]()
SQLCOLUMNS File
![]()
![]()
![]()
![]()
SQLINDEXES File
![]()
![]()
![]()
Creating a Reality SQL Catalog
![]()
![]()
![]()
![]()
Naming of Tables, Columns and Indexes
![]()
![]()
![]()
![]()
Reviewing Reality Dictionaries
![]()
![]()
![]()
![]()
Using Existing Reality Data Dictionaries
![]()
![]()
![]()
![]()
Checking a Column Definition
![]()
![]()
![]()
![]()
Indexes
![]()
![]()
![]()
Listing Columns and Indexes in Reality
![]()
![]()
![]()
![]()
Listing the Columns in a Table
![]()
![]()
![]()
![]()
Listing the Indexes for a Table
![]()
![]()
Setting Up a Working System
![]()
![]()
![]()
Setting-up the Host System
![]()
![]()
![]()
Setting-up the SQL/ODBC Software on a PC
![]()
![]()
![]()
![]()
Configuring the Standard Network Interface
![]()
![]()
![]()
![]()
Setting-up the SQL/ODBC Data Source
![]()
![]()
![]()
Setting-up the SQL/JDBC Software on a Client System
![]()
![]()
![]()
![]()
Connecting using SQL/JDBC
![]()
![]()
![]()
Troubleshooting
![]()
![]()
![]()
![]()
Host Configuration
![]()
![]()
![]()
![]()
Reality User-id
![]()
![]()
![]()
![]()
SQL/ODBC
![]()
![]()
![]()
![]()
SQL/JDBC
![]()
![]()
Catalog Administration from TCL
![]()
![]()
![]()
Introduction
![]()
![]()
![]()
![]()
Syntax
![]()
![]()
![]()
![]()
Using a Select List
![]()
![]()
![]()
![]()
Creating the SQL Environment
![]()
![]()
![]()
![]()
SQL Catalog Files
![]()
![]()
![]()
![]()
Main Menu
![]()
![]()
![]()
Using the SQLM Menu Options
![]()
![]()
![]()
![]()
Entering File and Table Names
![]()
![]()
![]()
![]()
Selecting from a List
![]()
![]()
![]()
![]()
Amendments Screens
![]()
![]()
![]()
Option 1: Create New Table Definitions
![]()
![]()
![]()
![]()
Initial Procedure
![]()
![]()
![]()
![]()
Automatic Conversion of Data/Index Definitions
![]()
![]()
![]()
![]()
Manual Selection of Data/Index Definitions
![]()
![]()
![]()
![]()
Creating a Table for a File with no Data Definition Items
![]()
![]()
![]()
Option 2: Create Alternative View
![]()
![]()
![]()
Option 3: View Table Definitions
![]()
![]()
![]()
![]()
Viewing Privilege Grants
![]()
![]()
![]()
![]()
Viewing Primary Keys
![]()
![]()
![]()
![]()
Viewing Foreign Keys
![]()
![]()
![]()
![]()
Viewing Column Definitions
![]()
![]()
![]()
![]()
Viewing Index Definitions
![]()
![]()
![]()
Option 4: Amend Table Definitions
![]()
![]()
![]()
![]()
Updating Privilege Grants
![]()
![]()
![]()
![]()
Updating Primary Keys
![]()
![]()
![]()
![]()
Updating Foreign Keys
![]()
![]()
![]()
![]()
Updating a Column Definition
![]()
![]()
![]()
![]()
Updating Index Definitions
![]()
![]()
![]()
![]()
Toggling Update Permission
![]()
![]()
![]()
Option 5: Regenerate Table
![]()
![]()
![]()
Option 6: Rename Table
![]()
![]()
![]()
Option 7: Remove Table From SQL Environment
![]()
![]()
![]()
Option 8: Verify Table(s)
![]()
![]()
Catalog Administration from a PC
![]()
![]()
![]()
What is WinSQLM?
![]()
![]()
![]()
![]()
Starting WinSQLM
![]()
![]()
![]()
![]()
Context Sensitive Help
![]()
![]()
![]()
Administering and Connecting to an SQL Catalog
![]()
![]()
![]()
![]()
Configuring a Data Source
![]()
![]()
![]()
![]()
Connecting to an SQL/ODBC Data Source
![]()
![]()
![]()
Working with the WinSQLM Window
![]()
![]()
![]()
![]()
Menu Commands
![]()
![]()
![]()
![]()
Toolbar Commands
![]()
![]()
![]()
Creating a New Table Definition - Overview
![]()
![]()
![]()
Creating a New Table using Manual Selection of Data/Index Definitions
![]()
![]()
![]()
Creating a New Table using Automatic Conversion of All Data/Index Definitions
![]()
![]()
![]()
Creating a New Table using Automatic Conversion of Selected Data/Index Definitions
![]()
![]()
![]()
Creating a New Table For a File with No Data Definition Items
![]()
![]()
![]()
Opening a Table Definition
![]()
![]()
![]()
Viewing and Updating a Table Definition
![]()
![]()
![]()
![]()
Columns Page
![]()
![]()
![]()
![]()
![]()
Alternative View of Column Definition
![]()
![]()
![]()
![]()
![]()
Adding a Column Definition
![]()
![]()
![]()
![]()
![]()
Updating Column Definitions
![]()
![]()
![]()
![]()
![]()
Changing a Cell
![]()
![]()
![]()
![]()
![]()
Renaming a Table
![]()
![]()
![]()
![]()
![]()
Deleting a Table Definition
![]()
![]()
![]()
![]()
Indexes Page
![]()
![]()
![]()
![]()
![]()
Deleting an Index
![]()
![]()
![]()
![]()
![]()
Adding an Index
![]()
![]()
![]()
![]()
Privileges Page
![]()
![]()
![]()
![]()
![]()
Updating Current Privilege Grants
![]()
![]()
![]()
![]()
![]()
Adding a New User or Security Profile Grant
![]()
![]()
![]()
![]()
![]()
Deleting a User or Security Profile Grant
![]()
![]()
![]()
![]()
Table Information Page
![]()
![]()
![]()
![]()
File Information Page
![]()
![]()
![]()
![]()
ODBC Test Page
![]()
![]()
SQL Column and Index Definitions
![]()
![]()
![]()
SQL Column Definition Fields
![]()
![]()
![]()
Conversion Codes in an SQL Column Definition
![]()
![]()
![]()
![]()
SQL Conversions to/from a Directly Connected Terminal
![]()
![]()
![]()
![]()
Data Generation
![]()
![]()
![]()
![]()
Output Conversion
![]()
![]()
![]()
![]()
Input Conversion
![]()
![]()
![]()
![]()
Update Conversion
![]()
![]()
![]()
SQL Index Definition Fields
![]()
![]()
Table/Column Definition Design
![]()
![]()
![]()
Introduction
![]()
![]()
![]()
Handling Multivalues and Subvalues
![]()
![]()
![]()
![]()
Accessing Multivalues or Subvalues in Columns
![]()
![]()
![]()
![]()
Examples of Handling Different Types of Multivalued Attributes
![]()
![]()
![]()
![]()
Techniques for Handling Multivalues
![]()
![]()
![]()
![]()
Examples of Handling Multivalued Data in a Single Row
![]()
![]()
![]()
![]()
Examples of Handling Related Multivalued Fields
![]()
![]()
![]()
Choosing Data Types
![]()
![]()
![]()
![]()
Column Type
![]()
![]()
![]()
![]()
Precision
![]()
![]()
![]()
![]()
Scale
![]()
![]()
![]()
Choosing Primary Keys
![]()
![]()
Application Index Design
![]()
![]()
![]()
Difference between SQL and Reality Indexes
![]()
![]()
![]()
![]()
Two-Step Index Creation Using TCL
![]()
![]()
![]()
![]()
One-Step Index Creation Using SQL
![]()
![]()
![]()
![]()
Differences Between TCL and SQL Creation Mechanisms
![]()
![]()
![]()
![]()
Processing a Query
![]()
![]()
![]()
![]()
Optimising a Query using Indexes
![]()
![]()
![]()
SQL Query Optimisation
![]()
![]()
![]()
![]()
Optimisation Methods
![]()
![]()
![]()
![]()
SQL Query Optimisation Rules
![]()
![]()
![]()
![]()
The use of Multiple AND/OR Clauses
![]()
![]()
![]()
![]()
Join Optimisation
![]()
![]()
![]()
![]()
LIKE Optimisation
![]()
![]()
![]()
![]()
Debugging Features
![]()
![]()
![]()
![]()
Index Matching Algorithm
![]()
![]()
![]()
![]()
Mismatch Problems
![]()
![]()
![]()
![]()
The ?missing values? Problem
![]()
![]()
![]()
Recommendations for Creating Indexes
![]()
![]()
![]()
Restrictions on Creating Indexes
![]()
![]()
SQL Statements Supported by Reality
![]()
![]()
![]()
Reality SQL
![]()
![]()
![]()
![]()
Data Types
![]()
![]()
![]()
![]()
Functions
![]()
![]()
![]()
![]()
SQL Views
![]()
![]()
![]()
![]()
Null Handling
![]()
![]()
![]()
![]()
Binary Data Types
![]()
![]()
![]()
Standards Compliance
![]()
![]()
![]()
![]()
SQL/ODBC
![]()
![]()
![]()
![]()
SQL/JDBC
![]()
![]()
![]()
![]()
![]()
Data Types
![]()
![]()
![]()
The SQL Command and Statements
![]()
![]()
![]()
![]()
The SQL command
![]()
![]()
![]()
![]()
SQL Statements
![]()
![]()
![]()
ALTER TABLE Statement
![]()
![]()
![]()
CALL Statement
![]()
![]()
![]()
CREATE INDEX Statement
![]()
![]()
![]()
CREATE PROCEDURE Statement
![]()
![]()
![]()
CREATE TABLE Statement
![]()
![]()
![]()
DELETE Statement
![]()
![]()
![]()
DROP INDEX Statement
![]()
![]()
![]()
DROP PROCEDURE Statement
![]()
![]()
![]()
DROP TABLE Statement
![]()
![]()
![]()
GRANT Statement
![]()
![]()
![]()
INSERT Statement
![]()
![]()
![]()
REVOKE Statement
![]()
![]()
![]()
SELECT Statement
![]()
![]()
![]()
UPDATE Statement
![]()
![]()
![]()
VERIFY Statement
![]()
![]()
![]()
SQL Search Condition
![]()
![]()
![]()
SQL Expression
![]()
![]()
SQL Stored Procedures
![]()
![]()
![]()
Writing Stored Procedures
![]()
![]()
![]()
BEGIN/END Statements
![]()
![]()
![]()
BREAK Statement
![]()
![]()
![]()
CONTINUE Statement
![]()
![]()
![]()
DECLARE Statement
![]()
![]()
![]()
IF/ELSE Statement
![]()
![]()
![]()
RETURN Statement
![]()
![]()
![]()
SET Statement
![]()
![]()
![]()
WHILE Statement
![]()
![]()
System Requirements
![]()
![]()
![]()
Host
![]()
![]()
![]()
Client
![]()
![]()
Setting up Logging
![]()
![]()
![]()
ODBC
![]()
![]()
![]()
![]()
Host-based Logging
![]()
![]()
![]()
![]()
ODBC Client-based Logging
![]()
![]()
![]()
![]()
PCSNI Logging
![]()
![]()
![]()
JDBC
![]()
![]()
![]()
![]()
Enabling Logging
![]()
![]()
SQL Reserved Keywords
![]()
![]()
SQL Environment Files
![]()
![]()
![]()
SQLINFO File
![]()
![]()
![]()
SQLTYPES File
![]()
![]()
![]()
SQLTABLES File
![]()
![]()
![]()
SQLCOLUMNS File
![]()
![]()
![]()
SQLINDEXES File
![]()
![]()
PERSONNEL File
![]()
![]()
![]()
Format of the PERSONNEL File
![]()
![]()
![]()
PERSONNEL Data
![]()
![]()
![]()
PERSONNEL Data definition items
![]()
UNIX-Connect
![]()
External Interfaces
![]()
Other Documents